<!-- This comment will put IE 6, 7 and 8 in quirks mode -->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<title>eCommerce: Plik źródłowy D:/CentrumXP/e-Commerce/eCommerceDev/SklepDAO/ErrorDAO.cs</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javaScript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css"/>
</head>
<body onload='searchBox.OnSelectItem(0);'>
<!-- Wygenerowano przez Doxygen 1.6.1 -->
<script type="text/javascript"><!--
var searchBox = new SearchBox("searchBox", "search",false,'Szukaj');
--></script>
<div class="navigation" id="top">
  <div class="tabs">
    <ul>
      <li><a href="index.html"><span>Strona&nbsp;główna</span></a></li>
      <li><a href="namespaces.html"><span>Pakiety</span></a></li>
      <li><a href="annotated.html"><span>Klasy</span></a></li>
      <li class="current"><a href="files.html"><span>Pliki</span></a></li>
      <li>
        <div id="MSearchBox" class="MSearchBoxInactive">
        <img id="MSearchSelect" src="search/search.png"
             onmouseover="return searchBox.OnSearchSelectShow()"
             onmouseout="return searchBox.OnSearchSelectHide()"
             alt=""/>
        <input type="text" id="MSearchField" value="Szukaj" accesskey="S"
             onfocus="searchBox.OnSearchFieldFocus(true)" 
             onblur="searchBox.OnSearchFieldFocus(false)" 
             onkeyup="searchBox.OnSearchFieldChange(event)"/>
        <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
        </div>
      </li>
    </ul>
  </div>
  <div class="tabs">
    <ul>
      <li><a href="files.html"><span>Lista&nbsp;plików</span></a></li>
      <li><a href="globals.html"><span>Składowe&nbsp;plików</span></a></li>
    </ul>
  </div>
<h1>D:/CentrumXP/e-Commerce/eCommerceDev/SklepDAO/ErrorDAO.cs</h1><a href="_error_d_a_o_8cs.html">Idź do dokumentacji tego pliku.</a><div class="fragment"><pre class="fragment"><a name="l00001"></a><a class="code" href="_error_d_a_o_8cs.html#a81a223a02c34d82b47199f08308847f2">00001</a> ﻿using <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>;
<a name="l00002"></a>00002 <span class="keyword">using</span> <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Collections.Generic;
<a name="l00003"></a>00003 <span class="keyword">using</span> <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Text;
<a name="l00004"></a>00004 <span class="keyword">using</span> <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data.SqlClient;
<a name="l00005"></a>00005 <span class="keyword">using</span> <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Web;
<a name="l00006"></a>00006 <span class="keyword">using</span> <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.IO;
<a name="l00007"></a>00007 <span class="keyword">using</span> ShopModel;
<a name="l00008"></a>00008 
<a name="l00009"></a>00009 <span class="keyword">namespace </span>ShopDAO
<a name="l00010"></a>00010 {
<a name="l00011"></a><a class="code" href="class_shop_d_a_o_1_1_error_d_a_o.html">00011</a>     <span class="keyword">public</span> <span class="keyword">class </span><a class="code" href="class_shop_d_a_o_1_1_error_d_a_o.html">ErrorDAO</a>
<a name="l00012"></a>00012     {
<a name="l00013"></a>00013         <span class="keyword">private</span> <span class="keywordtype">string</span> connectionString;
<a name="l00014"></a>00014 
<a name="l00015"></a>00015         <span class="keyword">private</span> SqlConnection Connection()
<a name="l00016"></a>00016         {
<a name="l00017"></a>00017             <span class="keywordflow">return</span> <span class="keyword">new</span> SqlConnection(connectionString);
<a name="l00018"></a>00018         }
<a name="l00019"></a>00019 
<a name="l00020"></a><a class="code" href="class_shop_d_a_o_1_1_error_d_a_o.html#a09b5147e5a86f86108638f1b3419f7bc">00020</a>         <span class="keyword">public</span> <a class="code" href="class_shop_d_a_o_1_1_error_d_a_o.html#a09b5147e5a86f86108638f1b3419f7bc">ErrorDAO</a>()
<a name="l00021"></a>00021         {
<a name="l00022"></a>00022             connectionString = <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Configuration.ConfigurationManager.ConnectionStrings[<span class="stringliteral">&quot;csShop&quot;</span>].ConnectionString;
<a name="l00023"></a>00023         }
<a name="l00024"></a>00024 
<a name="l00029"></a><a class="code" href="class_shop_d_a_o_1_1_error_d_a_o.html#a8462909756e9b2b12fe51652c30df227">00029</a>         <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="class_shop_d_a_o_1_1_error_d_a_o.html#a8462909756e9b2b12fe51652c30df227" title="Dodaje informację o błędzie do bazy danych (Adds information about the error that...">LogError</a>(Exception ex)
<a name="l00030"></a>00030         {
<a name="l00031"></a>00031             <span class="keywordflow">if</span> (ex != null)
<a name="l00032"></a>00032             {
<a name="l00033"></a>00033                 <span class="keywordtype">int</span> exeptionId = 0;
<a name="l00034"></a>00034                 SqlConnection connection = Connection();
<a name="l00035"></a>00035                 SqlCommand command = connection.CreateCommand();
<a name="l00036"></a>00036                 command.CommandType = <a class="code" href="_common_tools_8cs.html#a81a223a02c34d82b47199f08308847f2">System</a>.Data.CommandType.StoredProcedure;
<a name="l00037"></a>00037                 command.CommandText = <span class="stringliteral">&quot;LogError&quot;</span>;
<a name="l00038"></a>00038                 command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@message&quot;</span>, ex.Message));
<a name="l00039"></a>00039                 command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@call_stack&quot;</span>, ex.StackTrace));
<a name="l00040"></a>00040                 command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@parent_exception&quot;</span>, DBNull.Value));
<a name="l00041"></a>00041                 <span class="keywordflow">if</span> (!<span class="keywordtype">string</span>.IsNullOrEmpty(ex.Source))
<a name="l00042"></a>00042                 {
<a name="l00043"></a>00043                     command.Parameters.Add(<span class="keyword">new</span> SqlParameter(<span class="stringliteral">&quot;@source&quot;</span>, ex.Source));
<a name="l00044"></a>00044                 }
<a name="l00045"></a>00045 
<a name="l00046"></a>00046                 <span class="keywordflow">try</span>
<a name="l00047"></a>00047                 {
<a name="l00048"></a>00048                     connection.Open();
<a name="l00049"></a>00049                     exeptionId = Convert.ToInt32(command.ExecuteScalar());
<a name="l00050"></a>00050 
<a name="l00051"></a>00051 
<a name="l00052"></a>00052                     <span class="keywordflow">while</span> (ex.InnerException != null)
<a name="l00053"></a>00053                     {
<a name="l00054"></a>00054                         ex = ex.InnerException;
<a name="l00055"></a>00055                         command.Parameters[<span class="stringliteral">&quot;@message&quot;</span>].Value = ex.Message;
<a name="l00056"></a>00056                         command.Parameters[<span class="stringliteral">&quot;@call_stack&quot;</span>].Value = ex.StackTrace;
<a name="l00057"></a>00057                         command.Parameters[<span class="stringliteral">&quot;@parent_exception&quot;</span>].Value = exeptionId;
<a name="l00058"></a>00058 
<a name="l00059"></a>00059                         exeptionId = Convert.ToInt32(command.ExecuteScalar());
<a name="l00060"></a>00060                     }
<a name="l00061"></a>00061                 }
<a name="l00062"></a>00062                 <span class="keywordflow">catch</span> (Exception exception)
<a name="l00063"></a>00063                 {
<a name="l00064"></a>00064                     <span class="keywordflow">throw</span> exception;
<a name="l00065"></a>00065                 }
<a name="l00066"></a>00066             }
<a name="l00067"></a>00067         }
<a name="l00068"></a>00068 
<a name="l00069"></a>00069 
<a name="l00070"></a>00070     }
<a name="l00071"></a>00071 }
</pre></div></div>
<!--- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&nbsp;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&nbsp;</span>Klasy</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&nbsp;</span>Przestrzenie nazw</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&nbsp;</span>Pliki</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&nbsp;</span>Funkcje</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark">&nbsp;</span>Zmienne</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark">&nbsp;</span>Wyliczenia</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(7)"><span class="SelectionMark">&nbsp;</span>Właściwości</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(8)"><span class="SelectionMark">&nbsp;</span>Zdarzenia</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<hr size="1"/><address style="text-align: right;"><small>Wygenerowano Mon Nov 9 06:08:17 2009 dla eCommerce programem&nbsp;
<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.6.1 </small></address>
</body>
</html>
